package com.itbbfx.mapper;

import com.itbbfx.entity.Upplier;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface SupplierMapper extends Mapper<Upplier> {
    @Select("select * from upplier where state=0")
    List<Upplier> queryAll();

    //供货商的增删查改
    List<Upplier> findAllUpplier(Upplier upplier);
    int deleteUpplier(Integer supplierId);
    int editUpplier(@Param("upplier") Upplier upplier);
    int addUpplier(@Param("upplier") Upplier upplier);
    int count(Upplier upplier);
}